<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
 <%@ page import="java.util.* "%>
 <%@ page import="servlet.selectUsers" %>
 <%@ page import="servlet.ExportData" %>
 <%@ page import="java.io.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
<%
	ArrayList get_customer_data=new ArrayList();
    ExportData export_customer=new ExportData();
    get_customer_data=export_customer.getCustomerData();    
	//ArrayList selectuser=new ArrayList();
	//selectUsers su=new selectUsers();
	//selectuser=su.selUsers();
	

%>

</head>
<body>
<%response.setContentType("application/vnd.ms-excel");
  //response.setHeader("Pragma", "public");
  response.setHeader("Content-Disposition","attachment;filename"+"Leads"+".xlsx");
  //response.setHeader("Cache-Control", "max-age=0");
  %>
  <table>
  <tr>
  <font>
  	<td><b>Names</b></td>
  	<td><b>Email</b></td>
  	<td><b>Phone1</b></td>
  	<td><b>Phone2</b></td>
  	<td><b>Address1</b></td>
  	<td><b>Address2</b></td>
  	<td><b>State</b></td>
  	<td><b>City</b></td>
  	<td><b>Flat Type </b></td>
  	<td><b>Budget</b></td>
  	<td><b>Location</b></td>
  	</font>
  </tr>
  <%
 
 // for(int i = 0;i<selectuser.size();i+=2)
  for(int i = 0;i<get_customer_data.size();i+=11)
   { %>
      <tr>
         <td>
            	<%=get_customer_data.get(i)%>
         
          </td>
          <td>
          		<%=get_customer_data.get(i+1)%>
          </td>
          <td>
          		<%=get_customer_data.get(i+2)%>
          </td>
          <td>
          		<%=get_customer_data.get(i+3)%>
          </td>
          <td>
          		<%=get_customer_data.get(i+4)%>
          </td>
          <td>
          		<%=get_customer_data.get(i+5)%>
          </td>
          <td>
          		<%=get_customer_data.get(i+6)%>
          </td>
          <td>
          		<%=get_customer_data.get(i+7)%>
          </td>
          <td>
          		<%=get_customer_data.get(i+8)%>
          </td>
          <td>
          		<%=get_customer_data.get(i+9)%>
          </td>
          <td>
          		<%=get_customer_data.get(i+10)%>
          </td>
         
	  </tr>
  <%} %>
</table>
	

</body>
</html>